ALTER TABLE [dbo].[Venda]
DROP CONSTRAINT [Venda_new_new_new_pk]
GO

ALTER TABLE [dbo].[Venda]
ALTER COLUMN [CodigoVenda] int
GO


EXEC sp_rename '[dbo].[Venda].[Codigo]', 'CodigoOLD', 'COLUMN'
GO




ALTER TABLE [dbo].[Venda]
ADD [Codigo] int IDENTITY(1, 1) NOT FOR REPLICATION
GO

ALTER TABLE [dbo].[Venda]
ALTER COLUMN [Codigo] int NOT NULL
GO

ALTER TABLE [dbo].[Venda]
ADD CONSTRAINT [Venda_pk] PRIMARY KEY ([Codigo])
GO